[dbo].[vSoaMembershipSetting]

SQLServer > iMIS1521GA > Views > dbo.vSoaMembershipSetting

Properties
Columns
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	3:38:39 PM Friday, January 07, 2011
Last Modified	1:49:32 PM Thursday, September 22, 2011

Columns

Name
MembershipSettingId
Name
Value

SQL Script

CREATE VIEW [vSoaMembershipSetting]
AS
SELECT  CAST([System_Params].[ParameterName] AS VARCHAR(50)) AS [MembershipSettingId],
        SUBSTRING([System_Params].[ParameterName], 16, 100) AS [Name],
        CAST(ISNULL([System_Params].[LongValue], [System_Params].[ShortValue]) AS VARCHAR(6000)) AS [Value]
  FROM  [dbo].[System_Params]
WHERE  ([System_Params].[ParameterName] LIKE 'Member_Control%')

GO

Uses

[dbo].[System_Params]
dbo